Prerequisites
The following section describes the prerequisites for working with Qlik Replicate and an ODBC source with CDC.
Replicate server for Windows
You can connect an endpoint to Qlik Replicate using ODBC by indicating the DSN (Data Source Name). In this case you must be sure that a DSN is defined for the ODBC endpoint on the computer where Qlik Replicate is installed.
-
Install an endpoint client on the computer where Qlik Replicate is installed. The client you install depends on the ODBC provider you are using. For example, if you are using an IBM DB2 endpoint, install an IBM DB2 client.
Information noteYou must use a 64-bit ODBC provider client to work with Qlik Replicate
- Use the ODBC Data Source Administrator to create a System DSN.The Data Source is located in the Windows control panel.
Replicate server for Linux
The following section describes the steps for working with Qlik Replicate for Linux and ODBC with CDC as a source endpoint in a Replicate task.
- On the Qlik Replicate Server machine, install the ODBC client that you want to use (e.g. postgreSQL).
-
Makes sure that the /etc/odbcinst.ini file contains the correct entry for the driver you installed, as in the following example:[PostgeSQL]
Description = ODBC for PostgreSQL
Driver = /usr/lib/psqlodbc.so
Setup = /usr/lib/libodbcpsqlS.so
Driver64 = /usr/lib64/psqlodbc.so
Setup64 = /usr/lib64/libodbcpsqlS.so
FileUsage = 1
-
Define a DSN for the installed driver by editing the /etc/odbc.ini file, as in the following example:
[Postgre_DSN]
Description = Test
Driver = /usr/lib64/psqlodbc.so
Endpoint = MyDatabase
Servername = 12.3.45.678
Port = 5432